|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.13 03:52:00 -
[1]
Although we have fixed most of the bugs, I am sure people will find more. Also note, because of the increased size of the database, some may have issues installing it on some host. We look foward to see where the community takes this. We hope everyone enjoys this.
New Features: AutoSov¬ - Automatically adjusting fuel usages based on daily updated sovereignty information Moon Mining, Reaction Tracking, and Silo Tracking. Outpost Fuel Tracking - Allows you to track your pos system wide usages by defining which towers are filled from which outpost. Re-fueling calculator - You specify the time, it tells you how much fuel you need. and how many hauls it will take. Absolute Location of Towers to the moon. Faction towers and modules. Bug fixes and additions.
Requirements:
PHP 5 and MYSQL is required.
Download:
POS-Tracker 2.0.92
Installation:
Step 1. Download here and unpackage the files.
Step 2. Edit Config.php define('SQL_HOST','hostname'); #replace hostname with your database host name. This is usually localhost define('SQL_USER','username'); #Database username define('SQL_PASS','password'); # Database password define('SQL_DB','database'); # Database to use (e.g. pos_tracker) define('REDIRECT_PATH', 'http://'.$_SERVER['HTTP_HOST'].'/pos/'); #Path to your postracker
There are other optional settings found in config.php
Step 3. Edit header.php, mail.php, and postrackercron.sh
Step 4. Upload the tracker files.
Step 5. Browse to www.yourserver.com/postrackerpath/install.php If your server has trouble with this step, bigdump.php (you will have to edit with your database information).
Step 6. Remove install.php, install2.php create_database.sql, and bigdump.php
Step 7. Create a cronjob pointed to postrackercron.sh and have it run at least every 24 hours for the AutoSov¬, Mail Alert, and Alliance-Update. AutoSov¬ and Alliance Update will warn every 7 days if not updated.
Other Resources: [Pos Tracker] Developer Release 0.1 POS-Tracker 2.0 Beta Test
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.13 18:43:00 -
[2]
I have added all the fixes to the package. Also, the structure_static table dump had duplicate structures. I have provided a rar file with just the pages that have changed and the sql dump just for the structures. Also, pos_structures and reactor_info did not get cleared from the database dump.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.13 19:05:00 -
[3]
Originally by: Kivva Edited by: Kivva on 13/10/2007 19:02:01 Now that its up and running, I've noticed a discrepancy in calculated uptime for faction towers between viewing with the IGB and an external browser. Out of game, the uptime is incorrectly calculated to be 2 hours less than actual (in my case).
Also, I'm unable to assign a parent outpost to an existing tower from the IGB.
Which page? Tower size? Tower Race/faction? I'm not seeing it.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.14 00:18:00 -
[4]
Originally by: Kivva Edited by: Kivva on 13/10/2007 20:13:25 I think the time bug may be due to the scripts assuming hostile sov without the charid from the IGB, as I'm viewing with the 'admin' account. Suppose there isn't a very easy way to rectify that though, short of having a toggle for the admin account.
Only thing I can think of that would cause this is if you added the tower with the admin account. Does the tower display that the sov is hostile or friendly in one browser?
Originally by: CaldFighter liquid ozone in the outpost view doesn't seem to be calculating properly either.
also, slight annoyance, where it doesn't include the numbers in the outpost fields when you edit it so if you just change one field you have to add them all in otherwise it treats it as being empty.
hmmm, think you shouldn't have mentioned we might find more
*me goes to hide*
Im guessing the liquid ozone isn't calculating correctly on the main track page? It should be correct on view outpost page?
Originally by: Daevien Steiner Found a bug in mail.php on line 38
$email=$row['email'];
should be
$email=$row2['email'];
Without this, the mail notification will always fail as it's trying to mail to a blank variable.
Thats actually one of the few pages we did not touch, so I am guessing you found a bug from the version this is based off of.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.14 17:53:00 -
[5]
Originally by: CaldFighter
Track -> View (outpost) shows us 20 Liquid Ozone in the 'Required' column but heavy water is 500 which i'm assuming is total for pos's per hour.
Our pos's definaly use more lo than heavy water :)
I'll do some testing on that soon to see if I can figure out what is up.
Originally by: CaldFighter But silo's have a quirky bug in there, seems when you add them via add structures they don't seem to be getting linked to the POS in the db and so have had to manually update the pos_id field in both silo_info and reactor_info.
once done though you can change things about as normal.
Its adding the silos and reactors but not addding the pos_id? what value is giving the pos_id? Have you cleared out those duplicates in the structure_static table?
Originally by: franny view outpost, i'm getting .... POS's Currently being Tracked: Type: Serpentis Control Tower___System: Type: Serpentis Control Tower___System:
system is blank, now I know where my POS's are, but I think thats an error
that and the giant omgwtf every moon list in addpos step 4 seem to be my main 2 bugs sofar, but my testing was piecemeal today and tonights a busy night so not sure what i'll get done
Are your pos being assigned to systems properly? Does it have a systemID in the pos_info table?
Originally by: franny Edited by: franny on 14/10/2007 07:57:19 Edited by: franny on 14/10/2007 07:56:29 anyone try the semi standard setup yet?
silo\ ----reactor->silo->silo silo/
if so, does it track them properly too?, or does it say they are both filling?
ok, I set up to test it with this imaginary setup, set up about 3hrs ago Moon Harvester(not listed in the display) , it is feeding both at the same time
Will it do that ingame? I think that may be a little to complex to try and do in this tracker.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.15 16:20:00 -
[6]
Originally by: CaldFighter
Originally by: Johnathan Roark
Its adding the silos and reactors but not addding the pos_id? what value is giving the pos_id? Have you cleared out those duplicates in the structure_static table?
pos_id is 0 in the db, once it's changed to the correct pos it works fine though so must be when there added.
and yep, cleared out all the structures. I'd already put in the pos's, silo's, etc before i realised so was easier to remove them, clear the db and start again so can link each structure to the right pos.
Once it's added though everything is working great and huge thanks for all the work gone into it.
In pos-transaction.php, after line 328 add the following line: (integer) $pos_id=$_POST['pos_id'];
This is probably what is causing most of the Silo problems. Some php installs are more picky about correct syntax then others, which is a good thing.
Originally by: Salia Deluri OK going to sleep now but this one thing was bugging me hehe bugging and I have a question
silo1 --> reactor -- > silo 2
is silo 1 input or output for direction is silo 2 input or output for direction
Silo 1 would be an input, Silo 2 would be an output
Originally by: Salia Deluri
as for the bugging thing. int he reaction table material 21 is made from 2 and 3 not 2 and 5 :) Like I said I'll go through them tomorrow to see what I found. But now I can sleep Thanks again guys
Thanks, those tables where not fun to make and I'm not surprised by any errors in them. Just get me the entry number (first collum in the table) and I'll try to correct them.
Originally by: franny
works ingame, I have 2 POS's set that way, adv reaction otherwise I am emptying it every 3days or so
That wont be an easy fix.
Originally by: Gorfob I take it you want us to use the SourceForge bug tracker and feature requests pages?
Just post them in this thread for now.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.16 05:05:00 -
[7]
Originally by: Salia Deluri
line 328 or line 358? what's above and below please. Thanks, -Deluri
328, these are the previous 5 lines:
case 'Done': if ($_SESSION['access'] >= "2" || $_POST['owner_id']==$_SESSION['id']) { for ($n = 1; $n <= $_POST['amount']; $n=$n+1) { $s_id = $_POST['s_id' . $n];
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.17 17:48:00 -
[8]
Originally by: darkst0rm the email feature seems broken.
[root@venus pos2]# ./postrackercron.sh PHP Notice: Undefined variable: _SESSION in /var/www/virtuals/postracker/html/pos2/functions.php on line 652 PHP Notice: Undefined index: reinforced in /var/www/virtuals/postracker/html/pos2/mail.php on line 35 PHP Notice: Undefined index: email in /var/www/virtuals/postracker/html/pos2/mail.php on line 38 sendmail: fatal: No recipient addresses found in message header PHP Notice: Undefined variable: _SESSION in /var/www/virtuals/postracker/html/pos2/functions.php on line 652 PHP Notice: Undefined index: reinforced in /var/www/virtuals/postracker/html/pos2/mail.php on line 35 PHP Notice: Undefined index: email in /var/www/virtuals/postracker/html/pos2/mail.php on line 38 PHP Notice: Undefined variable: _SESSION in /var/www/virtuals/postracker/html/pos2/functions.php on line 652 PHP Notice: Undefined index: reinforced in /var/www/virtuals/postracker/html/pos2/mail.php on line 35 PHP Notice: Undefined index: email in /var/www/virtuals/postracker/html/pos2/mail.php on line 38 Message delivery failed...
I'll have to look into it, this is not something we actually touched, so it may take a while.
Originally by: CaldFighter i think i found a huge flaw with the auto-sov...
If you have constellation sov 4, the capital system gets a pos 'bonus' to fuel but the surrounding systems don't BUT they register as having sov 5 so the tracker thinks it's getting the bonus.
Not sure if it's easy to address or not?
Its not hard to change at all. functions.php, line 622 change from: if($row['constellationSovereignty'] > 0) { to: if($row['constellationSovereignty'] > 0 && $row['sovereigntyLevel'] >= 4) {
That will fix it, but i thought that all systems in the constellation should get the bonus? At least thats how I read it in the dev blog. My only POS in a constellation sov system is in the capital.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.17 18:44:00 -
[9]
Edited by: Johnathan Roark on 17/10/2007 18:44:45
Originally by: Shime There is an error with fuel usage (only on small minmattar and domination minmatar). When we ve a constellation sov, the calc is wrong
If i do same with large tower, there is no problems.
Any idea where is the problems?
So your saying the other races are fine or you have not tested them? Also, is this in the capital?
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.23 05:39:00 -
[10]
Originally by: Juan Pollo
Originally by: Barwinius Is PHP5 a hard requirement?
As near as I can tell... kinda yes. It seems that there are some things in the SOV and Alliance update scripts that don't much care for PHP4. On the other hand, as long as you don't mind it bugging you constantly to update those two, it seems to work well otherwise. That's just my personal experience.
yes, the update scripts are currently coded for php 5 only. PHP 5 has a lot better xml support then PHP 4. If someone wants to do it, as in someone other than me, it would not take much to port them to php 4. I will test them and then include them, but they will not be supported by me and there use will be discouraged. Another thing to keep in mind that php 4 has reached its end of life.Php.net So it really is in your best interest to migrate to php 5 if possible. One of my host this is as simple as using a custom .htaccess file in folders that I want to use php 5.
Text from the announcement can be found here:
Originally by: php.net The PHP development team hereby announces that support for PHP 4 will continue until the end of this year only. After 2007-12-31 there will be no more releases of PHP 4.4. We will continue to make critical security fixes available on a case-by-case basis until 2008-08-08. Please use the rest of this year to make your application suitable to run on PHP 5.
Corporation Management Improvement |
|
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.24 05:10:00 -
[11]
Originally by: Revanom When i try to run install.php after the edits i get this:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 134 bytes) in /home/XXXXXXXX/public_html/igb/postracker/install.php on line 8
HELP!
This is exactly the reason i've included bigdump.php in the package. I said in the first post that if you have any problems with install.php, use bigdump.php instead.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.26 18:09:00 -
[12]
Originally by: Ares Splinter Edited by: Ares Splinter on 26/10/2007 18:02:13 http://xxxxxxxxx/xxxxxxxxxx/user-transaction.php
Error 404 when i try to reg..
So i try to login and it redirects me to an old postrack directory..
http://xxxxxxxxxx/pos/failure.php
directory doesnt exist, and neither does its database...
you forgot to edit line 9 in config.php define('REDIRECT_PATH', 'http://'.$_SERVER['HTTP_HOST'].'/pos/');
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.09 20:17:00 -
[13]
Originally by: Mestoth "Error at the line 3001: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
Query: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14)' at line 1"
1stly: im a nublet with PHP and MYSQL. Im still not sure if i have this set up correctly :P secondly: i got the same "ran out of room error" so went onto the bigdump.php hence the above message. Im a bit confused and generally looking lost :P
oh, any chance you can create a nice "idiot proof" guide :) Installing PHP and MYSQL is easy, and doing the simple config stuff wasnt a prob. but im WAY outa my league right now :P
My guess is your running into a actual size issue with your host? I'd check with your host about size restrictions on your database.
There is no way i can make an idiot proof guide. Each host is different and someone will find some way to mess it up. The install scripts are the closest we can come to that.
Originally by: Vincent Liftor I used the bigdump.php file to load the sql information but when I go to the install.php file to create the admin account, I am still getting the error: Fatal error: Out of memory (allocated 74186752) (tried to allocate 134 bytes)
Can you provide some guidance for how to get around this?
your running the wrong install file, if you run bigdump.php, you need to run install2.php (notice the '2' in the name) which should be linked from bigdump.php.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.10 16:20:00 -
[14]
Originally by: Vincent Liftor Another quick question, once a tower has been added to the tracker, how can you add a tower name if none was entered at creation? There doesn't seem to be an edit field for the tower name or really any other way to change this information currently.
Thanks!
Only current way is to manually edit it in the database.
Originally by: Lillis85 I'm having troubles importing the database using bigdump.
Quote: Error at the line 2001: SERT INTO `evenames` (`itemID`, `itemName`, `categoryID`, `groupID`, `typeID`) VALUES (40001884, 'Psasa III - Moon 15', 2, 8, 14);
Query: SERT INTO `evenames` (`itemID`, `itemName`, `categoryID`, `groupID`, `typeID`) VALUES (40001884, 'Psasa III - Moon 15', 2, 8, 14);
MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SERT INTO `evenames` (`itemID`, `itemName`, `categoryID`, `groupID`, `typeID`) V' at line 1
After trying to decrease the ammount of lines importing per cycle I get the same error but on another line. The error seems to appear on the second cycle every time, no matter how many lines I choose to import per cycle. I'm running everything on my local computer. What could be the cause of this?
Honestly, I have no clue.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.11 23:04:00 -
[15]
Originally by: Shime Hello,
Another question ; how work the "secret pos" system ??
Under sql i write 1 to secret pos, but the owner don"t see his own pos after ?? I do not want that all members can see all the pos position and status with the pos tracker.
the secret POS is related to highly trusted flag in the user table. This is an incomplete feature but It think is the only things that are missing is the toggle for highly trusted and secret pos.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.14 06:57:00 -
[16]
Originally by: Wipster Hey, There seem to be alot of bug fixes in this thread and looking at the sourceforge release its a month old and the svn hasn't been touched in about the same, where abouts can I get my hands on an up to date copy or when would a new release be scheduled? Great tool btw, I used an old version for a while, looking forward to the new functionality.
There really hasn't been many fixes since the last version. I think the SVN has a few more fixes. The only other bugs are small ones in the database, the code should be current as of reversion 95.
I have been considering changing the way it handles passwords. Currently it uses a method that is vulnerable to a rainbow attack, which is no big deal as long as no one gets a copy of your database. I would attempt to make it so you can stay with the current method if I did make this change. Upgrading would mean deleting all the users and asking everyone to re-register.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.18 06:37:00 -
[17]
Originally by: Xawen Can someone post a simple howto for getting reactions set up on the page? I can't seem to get one to start calculating and show up on the POS View page.
Right now I'm just trying a simple reaction: silo 0 (cadmium) | Reactor --- silo 2 (Caesarium Cadmide) | silo 1 (caesium)
First I set the reactor material to caesarium cadmide. Then I set silo 0 and 1 to the right material, then set them to input and assigned them to the reactor marked caesarium cadmide. Then, I set silo 2 to caesarium cadmide, output and assigned to the reactor. I gave silos 0 and 1 15000 units of material and assumed it would start computing the reaction, but nothing happened. I'm sure I'm missing something simple, but I can't figure out what.
Anyone know what I screwed up?
Try updating the materail in silo 2. Also make sure silo 0 and 1 are set to input. Other than that, I can't tell much without seeing it.
Originally by: Elfishy when trying to update sov:
Fatal error: Call to undefined function curl_init() in /var/www/possy/updatesov.php on line 14
or when trying to update alliance list:
Fatal error: Call to undefined function curl_init() in /var/www/possy/updateallianceinfo.php on line 14
My guess is your host has CURL disabled. That would mean you have 3 options: get them to enable it, switch host, bribe me/someone to convert it to fopen.
Try running the following code on your host: <?php
$curl_version=curl_version(); echo "Your CURL Version: ".$curl_version['version']."<br>";
?>
Originally by: CaldFighter anyone notice Liquid Ozone and Heavy water don't seem to calculate properly in outpost view?
Liquid Ozone says 55 but should be closer to 600 Heavy Water says 800 but should be closer to 450
Apart from that, we've had no problems.
Yea, thats one of the bugs that would be easier for Rx to look at as he wrote that part.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.24 06:14:00 -
[18]
Edited by: Johnathan Roark on 24/11/2007 06:17:27
Originally by: Shime Another error in database with true sansha medium tower
When u have the sov 1, we can see 5 oxygen,2 mechanical,35 hvy water,39 Liquid / hour.
Or in reality : 6,3,42,42
I found the error in sovereignty_static database, but don"t find where i can change the hvy water and LO. (cause in this database there are ok)
I think your seeing a bug in EVE, not POS-Tracker. EVE starbase control pannel displays the max Liquid ozone and heavy water used per hour. POS-tracker calculates actual use based on the structures you tell it that you have online.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.24 18:52:00 -
[19]
Originally by: Wipster Hey, I'm just setting up the tracker and I'm a bit stuck, we have a reactor going into a silo and then another reactor taking from that silo (because we produce more then we can second reaction) is there a way to let a silo be an input aswell as an output?
Wip
No, sorry, the silo tracking is a simple solution and can't cover all the possibilities, just most of the more common setups.
With some miner modifications, you probably could trick it into giving the data you want.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.29 07:02:00 -
[20]
Originally by: Shime
Originally by: Johnathan Roark Edited by: Johnathan Roark on 24/11/2007 I think your seeing a bug in EVE, not POS-Tracker. EVE starbase control pannel displays the max Liquid ozone and heavy water used per hour. POS-tracker calculates actual use based on the structures you tell it that you have online.
Can"t be that, i saw the problem because ive got somes differences enter the fuel into the tower and on the pos manager.
Yea, your right. I am guessing a rounding error. Others may have the same issue.
This should fix that one: UPDATE `sovereignty_static` SET `oxygen` = '6', `mechanical_parts` = '3' WHERE `sovereignty_static`.`pos_race` =14 AND `sovereignty_static`.`pos_size` =2 AND `sovereignty_static`.`isotope` =127 AND `sovereignty_static`.`oxygen` =5 AND `sovereignty_static`.`mechanical_parts` =2 AND `sovereignty_static`.`coolant` =3 AND `sovereignty_static`.`robotics` =1 AND `sovereignty_static`.`uranium` =2 AND `sovereignty_static`.`ozone` =42 AND `sovereignty_static`.`heavy_water` =42 AND `sovereignty_static`.`strontium` =56 AND `sovereignty_static`.`capacity` =55000 AND `sovereignty_static`.`strontium_hanger` =25000 LIMIT 1 ;
Corporation Management Improvement |
|
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.30 19:24:00 -
[21]
POS-Tracker's future:
To me, it seems most of the bugs have been worked out. Most of the remaining ones seem to be typos in the database exports.
I am now beginning to look toward a 2.1 version and I am wondering what everyone would like to see in it? Currently I am looking at the new starbase api features and how to add them into the tracker. This should be rather easy if we get moon location IDs. This may require some database changes, hopefully nothing too major. I have also been looking at making the install process a little better. The Secret POS/Highly Trusted needs finishing. We where also intending on adding a comment box for towers that we never go arround to coding. The field for this is already in the database.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.30 20:50:00 -
[22]
Originally by: Shime perfectly work ! thks a lot.
In future addon-patch, can u create some a buttons, to order track.php by what we want. That will help when we have many tower.
Because, by default, this is order by Tower Name. Thinks that will be more easy by owner or system name.
Great job anyways
yea, that shouldn't be too hard to do. I'll probably change the default to system Name anyway. The Tower name is a relic from when it wasn't associated with a specific system.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.07 07:32:00 -
[23]
Originally by: Tiger Wolf I just downloaded the current version and got it installed today. I got the pos put in the thing but for some reason the information that I put in the corp hanger array for fuel doesnt save. The only button I see to save it is the update fuel button above the hanger array area. I dont know if there is a button missing or something or what, but thought I would say something, maybe someone has a fix for me...
Thanks, TW
Yes, its missing, I know I've added it back several times. I'll edit this post tomorrow with whats missing, time for bed now.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.08 06:33:00 -
[24]
Originally by: Tiger Wolf I just downloaded the current version and got it installed today. I got the pos put in the thing but for some reason the information that I put in the corp hanger array for fuel doesnt save. The only button I see to save it is the update fuel button above the hanger array area. I dont know if there is a button missing or something or what, but thought I would say something, maybe someone has a fix for me...
Thanks, TW
Lines 385-387 should look like this in editpos.php
echo "<tr><td><a href=\"showinfo:16275\">Strontium Calthrates</a></td><td>" . $row['strontium'] . "</td><td><input type=\"text\" name=\"hanger_strontium\" value=\"" . $row['strontium'] . "\" size=10></td><td>-</td></tr>"; echo "</table><p><input type=\"submit\" name=\"action\" value=\"Update Hanger\"></form>"; echo"</table></form><br>";
Originally by: Priory Edited by: Priory on 07/12/2007 12:14:49 $conn = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS) or die('Could not connect to the database; ' . mysql_error()); mysql_select_db(SQL_DB, $conn) or die('Could not select database; ' . mysql_error());
Those are lines 11-15 from an unchanged config.php Every time I try to install it, I get "Parse error: syntax error, unexpected T_STRING in /home/tplacom/public_html/station/config.php on line 12"
Also tried running install2.php and I get a 'Access to database: denied" I know my passwords and all that jazz are correct though.
/me is a noob at this kinda stuff
Check these linkes again in the config.php file, also remember, it should be renamed to config.php from config.dist.php.
define('SQL_HOST','sql_host'); define('SQL_USER','your_username'); define('SQL_PASS','your_password'); define('SQL_DB','database_name');
The quotes also need to remain on each line, as in the following example, but please don't use password as your password define('SQL_PASS','password');
Originally by: Metalstein Edited by: Metalstein on 08/12/2007 02:50:44 Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\XAMPP\htdocs\pos\functions.php on line 608
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in E:\XAMPP\htdocs\pos\functions.php on line 608
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\XAMPP\htdocs\pos\register.php on line 12
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in E:\XAMPP\htdocs\pos\register.php on line 12
Getting this on trying to register. Yes, I am using XAMPP. It's a pretty handy application.
First thing that jumps out at me is it says your not using a password, which if its not set correctly it would cause this. The other thing I am not sure about is the ODBC, I haven't used it and not sure if it understands the mysql commands. One thing I would check is if the tables where created and did you use the one of the install scripts included to do so?
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.08 17:11:00 -
[25]
Originally by: Metalstein Edited by: Metalstein on 08/12/2007 08:11:38 Figured out my problem. I tried setting this up earlier on EasyPHP and got it working eventually. Had to change config.dist.php to config.php. Then it worked fine.
I promptly forgot that I did this and tried Pos Tracker on XAMPP. So I was confused as hell for a bit :) Renamed it once more and it works again.
Why does the config file come with the default name of config.dist.php anyways?
So it doesn't accidentally get over written.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.18 06:59:00 -
[26]
Originally by: Ulrich Smith
Originally by: Johnathan Roark POS-Tracker's future:
To me, it seems most of the bugs have been worked out. Most of the remaining ones seem to be typos in the database exports.
I am now beginning to look toward a 2.1 version and I am wondering what everyone would like to see in it? Currently I am looking at the new starbase api features and how to add them into the tracker. This should be rather easy if we get moon location IDs. This may require some database changes, hopefully nothing too major. I have also been looking at making the install process a little better. The Secret POS/Highly Trusted needs finishing. We where also intending on adding a comment box for towers that we never go arround to coding. The field for this is already in the database.
Is there a ver 2.1 download out there that has all of the fixes and changes included?
No not yet, I hope to have a testing version of 2.1 out in the next week or two. This will be mostly database changes and the addition of the EVEAPI stuff(which is really cool btw). I'm planning on changing the way passwords are stored.
Upgrading from 2.0.94 to 2.1 wont be direct. There are almost are too many database changes along with the password storage change to work. This shouldn't be a problem as most will be able to add there towers from the eveapi. I am also planning on making a xml export/import script so everyone can import there structures and outpost into 2.1 versions. This will also make it easier to change servers and make a backup. I don't intend to export/ import the user table. If for some reason anyone thinks this will be a problem for them, please post or evemail me. SVN is up to date under branches/2.1/ if anyone wants live on the edge and isntall that. The manual API update scripts are currently broken and only 2 of the regional moon SQL files are finished. the other ones included need the table name changed if you want to use them. I'll get the rest done sometime this week hopefully.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.19 17:37:00 -
[27]
Originally by: Shime Edited by: Shime on 19/12/2007 13:48:50 Hello, Since trinity, there is an error when trying to update the alliance list :
Could not select Member; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1
If anyone have an idea ??
(if using katet zip files, update are ok)
Change: foreach ($xml->xpath('//row') as $row) { To: foreach ($xml->xpath('/eveapi/result/rowset/row') as $row) {
That should work, the eveapi xml structure changed. Before, it was grabbing every element called row, taking the allianceID and seeing if it was already in the database, If not, it added it to the database. Now they've added corporations to the alliance list, it can't find an allianceID in the first row for a corporation and then the sql is invalid.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.19 19:41:00 -
[28]
Originally by: Linkex
Originally by: Mestoth "Error at the line 3001: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
Query: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14)' at line 1"
Anyone find the cause of this yet? I've tryed it on our live server and my test server, same issue. I've checked the sql file, line 3001 dosen't have any syntax errors I can see.
I have no max database size on my test server, plus its only getting about 300kb into the database with this.
try manually creating the database by copy/pasting creat_database.sql into something like phpmyadmin?
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.20 08:18:00 -
[29]
Originally by: Linkex
Originally by: Johnathan Roark
Originally by: Linkex
Originally by: Mestoth "Error at the line 3001: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
Query: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14)' at line 1"
Anyone find the cause of this yet? I've tryed it on our live server and my test server, same issue. I've checked the sql file, line 3001 dosen't have any syntax errors I can see.
I have no max database size on my test server, plus its only getting about 300kb into the database with this.
try manually creating the database by copy/pasting creat_database.sql into something like phpmyadmin?
Thanks. I got it to work properly in the end, I used ini_set at the top of the install script to set the timeout to 10 mins (600 secs). Took approx 8 mins on my host.
That makes me think its a problem with size of the database. Although physical space may not be a limitation, most php installations have a script execution time limit. This should go away in the next version, I am breaking up the moons by region, which will help with performance as you'll only have to add the moons in the regions you operate in.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.20 19:54:00 -
[30]
Originally by: Nina Mires
I am missing something when it comes to the silo configuration? I would have expected to see a silo fuel (as it were) monitor on the track pos page?
I have planned on adding a view to the main track page for silos, but its one of those things I haven't had a chance to do.
Originally by: Nina Mires
Need to get my head around how you've done the Sov checking / calculations, but these are some really great additions to a program that is almost essential for maintaining a number of pos's.
Sovereignty is updated through the eveapi into a table called system_status. When it needs to know which table to get the fuel info out of it sends the systemID to a function called getsovstatus(), which returns the name of the proper table to use. depending on sovereignty level. It needs to be updated to check to make sure the the towers alliance and the sov holder are the same.
Corporation Management Improvement |
|
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.21 17:32:00 -
[31]
Originally by: Hsnopi so i downloaded this. looks cool. 1. config.dist.php has to be renamed to config.php 2. is the sql the entire eve database? I already have that so can you provide a smaller sql for if we don't have that already installed? or do i need to uninstall my entire database and reinstall it now? (the tables for all of the eve database) 3. in /usr/local/bin/php mail.php /usr/local/bin/php cron_updatesov.php /usr/local/bin/php cron_updateallianceinfo.php
are these fiels going to be written to thsoe locations? or was I supposed to alter them to my path to PSO tracker? thanks Hsnopi
1. yes, config.dist.php needs to be renamed 2. No, it uses some parts of the eve database dump but modified to better suit this app. 3.No, you shouldn't have to edit that file at all unless you do not want one of those 3 files to run. The path has to do with your php install and it should be fine unless your running a weird setup.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.21 18:55:00 -
[32]
Originally by: Hsnopi on running install after creating database.... Fatal error: Allowed memory size of 20971520 bytes exhausted (tried to allocate 33723647 bytes) in /<path>/install.php on line 7
which is the file_get_contents. you may want to break that up into various seperate files. You also may want to consider using repalce instead of insert incase of errors on original install. I assume if you have created the db using bigdump or sourceing the file you have touse install2.php?
I would love to help debug this if youa re interested. if not i will shut up:)
i've included a copy of bigdump.php which should be able to handle the database size. 2.1 will have the moons broken up by region
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.23 08:17:00 -
[33]
I've put a 2.1.0 Beta package together. Please keep in mind that its not complete and a work in progress. yes, there are some bugs, some of the same ones that where in 2.0.94 are in this one. I recommend keeping your old installation until this has been finalized a bit more. If your not familiar with PHP, i suggest waiting. I would prefer bug reports that include possible or likely fixes, not bug real general bug reports telling me its broken.
EVEAPI POS support has been added, but is not complete. updatepos.php will update/add POS. addapi.php will allow you to add keys.
The database has had some changes made, mostly to support the eveapi. A prefix has been added to all the tables 'pos2_'. This is user configurable but the install scripts do not take the user definition into account yet. Moons have been broken up by region. You will only need to add/install those regions you have POS in.
The password hashing method has been changed. New method is currently PHP 5 only, but wont be a problem to include a PHP 4 version in the future. The old method for password hashing was insecure.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.27 19:24:00 -
[34]
Originally by: Shime just try and my comment :
1st : must activate curl under apache config to work. 2nd : when create admin account, there is an error and i can't create. i must insert manualy into sql.
3nd : when update pos list, there is an error : Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in .....updatepos.php on line 10
if we do "done" all seems ok, but there is no module on the pos setting (is it a problem or must we enter the setup?)
Anyway thats a great job.
1) yes, CURL is needed. Most cases its already on with a PHP 5 installation. Or at least that was my understanding
2) Happen to know what the error was, I think i've already corrected that though in the SVN.
3) Using more then one api key? I've fixed that in the svn already as well. I was overwriting the original sql result and then there wasn't any valid data for the next loop, which has also been fixed.
POS modules are not listed in the eveapi so I can't import them, you'll have to add them manually. I am planning on writing an export script for version 2.0.94 versions and an import script for 2.1.x versions. This isn't high on my priorties list though.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.29 17:40:00 -
[35]
Originally by: CyPhEr UmOs
In the database, what should be in the highly_trusted field for a highly trusted member? Default is 0 and when I change it manually to 1, 2 or 3 it doesn't change anything.
It does, notice the make classified button on edit pos when you have that set to 1? That will hide POS from those how do not have it set to 1.
Originally by: CyPhEr UmOs
I have added a Small Gallente POS with no problems. I added a Medium Shadow Control Tower POS and when I go back to view it I get the following errors:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /.../viewpos.php on line 175
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /.../viewpos.php on line 180
Warning: Division by zero in /.../viewpos.php on line 251 [/qoute] those lines tell me that you've added a silo and/or a reactor and something did not work right?
Originally by: CyPhEr UmOs
I also went to add fuel to the first pos that i had no issues with and got this message:
Error retrieving from pos_static in function uptimecalc;Table 'xxxxxxx_postracking.pos2_pos_race_specific' doesn't exist.
Im guessing on the fuel calculator? yea, i haven't gotten arround to removing refrences to that table yet.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.31 17:23:00 -
[36]
Originally by: Lillis85 I must say that this is a great tool! Very nice job to you guys! I have a problem though.
When I've added a POS with fuel and structures and then view it, it tells me that the sov status is hostile. It also looks like the fuel requirements are somewhat off. Looks like the bonus from the sov lvl is not kicking in and I can't figure out why the sov status is set to hostile when it shouldn't. The fuel requirements are perfect for our POSes in systems without sov. What could be the cause of this? I'm using the 2.0.94 version.
Thanks
Did you add the tower or are you viewing the tower with a character other than the corp that actually has the tower? This includes the admin account?
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.31 23:57:00 -
[37]
Originally by: IVannaTrump Edited by: IVannaTrump on 31/12/2007 22:44:31 when trying to browse to root/pos/addapi.php. I can input both fields, however I get an error 521. Any Ideas? Just As a note, I can update sov, and other cUrl info. I have cUrl enabaled.
HELP
Its an EVEAPI error code: "Invalid username and/or password passed to UserData.LoginWebUser()."
EVE API Error List
I would check your userid and apikey.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.01 20:16:00 -
[38]
Originally by: Lillis85 Edited by: Lillis85 on 01/01/2008 12:18:19 Edited by: Lillis85 on 01/01/2008 12:17:54
Originally by: Johnathan Roark
Originally by: Lillis85 I must say that this is a great tool! Very nice job to you guys! I have a problem though.
When I've added a POS with fuel and structures and then view it, it tells me that the sov status is hostile. It also looks like the fuel requirements are somewhat off. Looks like the bonus from the sov lvl is not kicking in and I can't figure out why the sov status is set to hostile when it shouldn't. The fuel requirements are perfect for our POSes in systems without sov. What could be the cause of this? I'm using the 2.0.94 version.
Thanks
Did you add the tower or are you viewing the tower with a character other than the corp that actually has the tower? This includes the admin account?
Ah yes, I was logged in as admin. Now it's friendly again, but the problem with slightly off fuel requirements are still there. The POS is in a capital constellation and the sov lvl displayed on the page is 5. It's a regular Large Gallente Tower. I have double checked the structures and which ones are offlined and onlined.
The fuels that seem to missmatch is oxygen, isotopes, liquid ozone, heavy water and strontium. Strontium is way off showing only half the required amount then it actually is. Shows 140 when it should be 300.
Edit: The CPU and PWG used are displaying correct numbers
Sorry, i didn't look at which version you where running, 2.0.94 fuel tables are incorrect. Im hoping the new ones are better, but I just spotted an error in those as well.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.03 17:33:00 -
[39]
POS-Tracker 2.1.0 BETA 1
This is release contains mostly bug fixes and some modifications to the EVE API POS update. There is now a link in the admin panel to add api keys as well as to run the update script. It requires access level 3 or higher to run. I've also included a copy for a cron job to run. I personally run it every other hour on my install. The only new feature in this release is the ability to rename towers if you have access level 3 or higher.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.03 20:39:00 -
[40]
Originally by: almooja seems as though it is missing some of the high sec systems.
Which regions, and where is it giving you problems? Those tables are copied from the eve data dump and the api.
Corporation Management Improvement |
|
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.04 19:42:00 -
[41]
Originally by: Aelena Thraant Great tool... A couple of issues I found so far
Outpost days of fuel status isn't correct if you don't have one of the towers it uses. For Example I have just amarr towers for this one outpost. I have all the types of fuel, but since it doesn't need oxygen isotopes the time left comes out 0 so the track screen shows 0
yea, thats one of the things im going to work on. I'll probably end up redoing some of it.
Originally by: Aelena Thraant
Reinforced is not being pulled from the api. We have a pos that was put into reinforced, but it's not showing up that way. It would be nice to see when it comes out as well.
That is something I want to add at some point, but since I don't have any towers in reinforced, its hard to test.
Originally by: Aelena Thraant
I would like to see the pos list on track.php to use 100% instead of a fixed size.
talking about font size or the table width?
Originally by: Aelena Thraant
It also would be nice to have it pull the outpost fuel from the asset list api call
I may do that, also considered seeing if I could get silos from it
Outpost and Silos are defently in need of some work. I plan to try and clean up some of the code and possibly rewrite some of it.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.07 04:00:00 -
[42]
Originally by: Aelena Thraant here is one (location and moon cleared to protect the por little pos :p) <row itemID="558526903" typeID="20060" locationID="xxxxx" moonID="xxxxx" state="3" stateTimestamp="2008-01-05 10:05:48" onlineTimestamp="2008-01-03 18:44:05"/>
I probably will be able to at least get it to change the state, im not sure about it timing the reinfroced atm, I'll have to look into it some more.
Originally by: Aelena Thraant
the table width
I have plans to do some better customizable stylesheets, but it needs to work in both the out of game browser and ingame browser.
Originally by: Rooky2001
same problem on my xampp server.
my Workaround in addapi.php:
Quote: #$ch = curl_init();
#curl_setopt($ch, CURLOPT_URL, $url); #curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); #curl_setopt($ch, CURLOPT_HEADER, false); #curl_setopt($ch, CURLOPT_POST, 1); #curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($data)); $url = "http://api.eve-online.com/account/Characters.xml.aspx?userid=".$userid."&apikey=".$apikey; if (!($contents = file_get_contents($url))){ exit; } $xml = new SimpleXMLElement($contents); #$xml = new SimpleXMLElement(curl_exec($ch)); #curl_close($ch);
Are you having problems with all the update scripts or just that one? did you need to do that hack on all of them or just that one? I'm guessing its how CURL is formating the POST values.
Originally by: Peter Kay Edited by: Peter Kay on 06/01/2008 21:52:59 Seem to be getting the following.
test3test1test2 Fatal error: Call to undefined function hash() in E:\WebSites\mc.friar.info\pos\password.php on line 12
When either doing the admin or registering a new user.
Updating from 5.1.2 which hash should be enabled by default, to 5.2.5 fixed the issue.
Thats odd, maybe an ISS/PHP issue that was fixed in 5.2.5?
Originally by: Peter Kay After some fun with hash then getting curl to work on IIS6. Put the API key in and get error 200
Which Means "Current security level not high enough."/>
Do we know what rights a character needs to view all pos for the corp?
I think you need a full key from a director in your corp to use.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.07 18:46:00 -
[43]
Originally by: Peter Kay Directors API key not working either both receive same Error 200.
Being new to EvE API makes debugging harder.
Rgds
PK
Make sure this is the second key.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.12 08:34:00 -
[44]
Originally by: Crotador
hash() function wasn't introduced until after 5.1.2 This should maybe check the version and adapt the code accordingly.
Im planning to look at adding some checks to the initial install page that will hopefully tell you if you'll have issues and what can be done to correct them.
Originally by: Crotador
My CEO would like his API key to be encrypted in the DB. Is this easily possible??
Yes, you would just need to add reversible encription, probably AES, functions to addapi.php, updatepos.php, and cron_updatepos.php. The only thing this would accomplish is making it so if someone got a copy of your database but did not get a copy of your code would not have the api key. There is nothing that can be done to keep the site admin from getting the key if he/she wants to. The site admin will have access to the encryption key. Thats why I have not taken the time to add this, as I see little value.
Originally by: Natasha Russo I get the following error any time I try to use the Fuel Calculator:
Error retrieving from pos_static in function uptimecalc;Table 'posadmin2.pos2_pos_race_specific' doesn't exist
That table was not created when I installed the beta version of the tracker. Could you clarify what needs to be done to have a functional fuel calculator?
Yea, i took that table out as it had very little in it and added it to the tower_static tables. I have already corrected it in the SVN. It still has a few miner calculation bugs that I need to work out. I'm hoping to have most of bugs i know about corrected sometime this weekend and release another package, which hopefully will be the final beta package.
Random possible ideas for future versions I have been experimenting with using templates to separate display code from actual app code. This would make it easier to customize the look. About anyone who knows HTML could do this. I am looking at how easy it will be to package this. Absolute paths work best, but finding what this is can be a pain on some host. I will release an a small test pack in a week or two with some basic templates requesting feedback on ease of installation, etc. Another issue I am also looking at, which may be related to wanting to separate display code from app code is access control. The current system isn't very clear and does not work well for everyone. If anyone has any ideas/suggestions on how to fix it and how it could be implemented, please let me know.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.16 04:28:00 -
[45]
Originally by: Natasha Russo Can you advise which files I would need to replace to fix this error? I don't want to have to download and reinstall the entire thing since I have already spent significant time going through all the files correcting spelling errors and the like. I would assume there are just a couple of replacement files that need to be loaded. Thanks!
Any chance you could tell me what these spelling errors are so I can get them correct. Your corrected files would do, Evemail me ingame on how to get them to me.
Originally by: Crotador
Suggestions: Would like to see who last updated the info on a pos.
Biggest issue with that would be how to treat those changed via api. I may add a log viewer at some point.
Originally by: Crotador
The fuel calculator should have an option to not include strontium.
I am assuming the trouble is the hauler part. I may add a second line excluding strontium.
Originally by: Crotador
For the access levels, I think just having a descriptive word for each level would help. It would also be nice to be able to set another person to level 4 so that they can approve other users.
I am looking at doing a bit more, but I'll probably add a description to the Admin pannel on what each level does. I have been considering changing it so the admin account is added at level 5, but I'll probably start getting request for an easy way to change other accounts to 5 then. Really the only thing 4 can do that 3 can't is change users to 3.
Originally by: Crotador
Templates: Have you looked at Smarty?
Yep, thats what I'm planning on using. Problem I ran into is it likes an absolute file path to the template directories and the class directory. I am afraid too many people will strugle with this.
Originally by: Blue Sassley I seen to get this error when I install some of the systems:
INSERT INTO `pos2_evemoons` ( `moonID` , `moonName` , `systemID` , `systemName` , `regionID` , `regionName` )VALUES ('40002090', 'Mohas II - Moon 1', '30000042', 'Moh', '10000001', 'Derelik')Database creation failed on step 2050. Please create database manually from file. Error Text: Duplicate entry '40002090' for key 1
You've attempted to install the same region twice into the moon database.
Originally by: CHAOS100 Your fuel calculation is incorrect with pos modules. I have 4 small railgun batteries, and the actual liquid ozone fuel timer is 3d 18h, the calculated timer on the site is 5d 6h. These are the error codes given at the top of the site:
When I test them, they are right on. I've updated the SVN so it now displays the max heavy water and liquid ozone a tower can use. So you'll see something like 22(29) where 29 would be what is displayed in the tower information. Some things to check for: Does your alliance have sovereignty in the system? Does the tracker have the Sovereignty Correct? Does the max usage match the tower info? Do you mods pg/cpu usage match whats listed in the tracker? Are your totals for pg/cpu the same? After updating from the SVN, if your still having problems, answer those questions along with what tower type you have an the sovereignty level and I'll see if that narrows it down.
Originally by: Myrdyr Edited by: Myrdyr on 13/01/2008 22:55:04 oh, and the problem is, i can get the reactors + silos set up but i can't update the quantities...after i type in the amounts and hit update they refresh back to zero...
Download the SVN version 110 or Change Line 449 to: $sql = 'UPDATE `'.TBL_PREFIX.'silo_info` SET `material_ammount` = \''.my_escape($_POST['material_amount']).'\' WHERE `'.TBL_PREFIX.'silo_info`.`silo_id` = '.my_escape($_POST['silo_id']).' LIMIT 1;';
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.20 07:43:00 -
[46]
Issue with the moon table and duplicates was caused by the fact that there are a few systems that are basically a shorter version of another. Mohas and Moh in Derelik are too good examples of this. The current version of the script I use to generate the moon tables uses a wild card to pull the moons out of evenames. I'm currently working on modifying this script to fix this.
Originally by: Myrdyr Edited by: Myrdyr on 20/01/2008 02:27:56 it's not ready for a new release quite yet, IMO. needs a lot of bugfixing, and a better db dump.
there's an error in the calculations that i've narrowed down to line 34 of viewpos.php
Quote: if ($pos_race == 1 || $pos_race == 2 || $pos_race == 3 || $pos_race == 4)
it makes every tower calculate as if it were an amarr tower...not sure what was intended here.
edit: also duplicated in editpos.php, line 39
The 2.0 version did not have any distinction between fuel requirements between the 4 main races. The few fields that did matter (cpu, pg, and isotope type) where stored in a different table, race_specific. You can safely remove those lines as long as you change refrences to $pos_race1 to $pos_race. That would explain why some where having issues with heavy water and liquid ozone calculations.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.22 17:21:00 -
[47]
Originally by: perry2 In the fuel calculator dont display isotopes that tower needs. It's due at line 175 of fuel_calculator.php.
This line needs an "s" $required_isotope = $row['isotope'];
This works $required_isotope = $row['isotopes'];
Are you using code from the SVN? Most of the bugs your finding have already been fixed.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.24 07:29:00 -
[48]
I have regenerated the moon install files. This should fix the ones with duplicate moons. I removed the old code to treat all 4 of the main races as the same race in functions.php, fuel_calculator.php, and viewoutpost.php. The hangar sizes where also missing from Caldari, Gallente, and Minmatar towers in the database. These changes can be found in the SVN. I think this is all the bugs that I know about and I'll try to package it up this weekend.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.25 19:10:00 -
[49]
Originally by: Cristiana hi
very nice tool, but is there any solution if there is the "error 521" ? I¦ve used a Full-Access-APIkey of an director of our corp... if i query the poslist on my own it works, but with the tool i¦m only getting the error as soon as i try to add the api-key at the admin-panel
thank you very much
There is a work arround at the top of this page. To actually fix it, I would need more details such as webserver software, OS, php and curl version.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.29 08:05:00 -
[50]
Originally by: Xies Edited by: Xies on 26/01/2008 04:27:14 I am having similar issues with passwords. For some reason, the password hash stored in the database is different to the password the 'comparepassword' function is getting passed to it from 'getPasswordHash'. Anyone have any ideas?
I've fixed the password.php file to properly salt the passwords. If you have a working install, do not overwrite your current password.php unless you want to delete all of your user accounts.
Originally by: Yarkan I have downloaded this Progrqamm from sourceforge.net. Just wanted to know which version you keep updating. Is that the link you posted here or is that the sourceforge.net . I am testing atm the sourceforge Version it looks quite nice
The link goes to sourceforge.net
Originally by: Yarkan Reaction Things. i have setted up a POS for a Reaction. So i seetted up 4 input Silos and 2 Output Silos. And assigned those silos to the Reaction. The Problem is when i am using 2 output Silos it will fill also 2 output Silos at once. Is there anything planned in the future that you can work with 2 output silos?
I am planning on redoing the silo tracking code, but don't expect it any time soon.
Originally by: Akyrah
from the SVN lines 65 and 69 in track.php need to be changed from
$where_statement = "WHERE tower_info.corp = '" . $_SESSION['corp'] ... to
$where_statement = "WHERE ".TBL_PREFIX."tower_info.corp = '" . $_SESSION['corp'] ...
Yea, missing table prefixes keep on popping up. Adding that is worth it, but if you find a bug, that would be the first thing that needs to be checked.
Originally by: Akyrah
in viewpos.php $hourstofill and $hourstogo should have a check to make sure > 0 to prevent a divide by zero error.
if($rate_vol > 0) { $hourstofill=floor($avalible_silo_vol/$rate_vol); }
if($rate > 0) { $hourstogo=floor($avalible_material/$rate); }
I've been meaning to do that.
Originally by: Akyrah
in viewoutpost.php, editoutpost.php added:
// determine if charters are needed $sql = "SELECT count(charters_needed) FROM pos2_tower_info p, pos2_outpost_info o WHERE p.outpost_name = o.outpost_name AND p.charters_needed = 1 AND o.outpost_id = ".$outpost_id; $result3 = mysql_query($sql) or die('Could not select from outpost_update_log; ' . mysql_error()); if (mysql_num_rows($result3) > 0) { $charters_needed = mysql_result($result3,0); }
for empire pos's that use charters.
I've added a simpler fix in the SVN for this. the outpost() function just needed to return if any POS requires charaters.
Corporation Management Improvement |
|
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.29 16:59:00 -
[51]
Originally by: Cristiana Edited by: Cristiana on 29/01/2008 08:50:30 PS: fixed by editing the updatepos.php with the same lines like addapi.php
What exactly did you change?
Originally by: Pronas is there a svn version ?
Yes, it is at sourceforge.net, POS-Tracker 2 Project
Originally by: Pronas
How contribute to this project ? i have fix the update api code how can only work with 1 api key and fix some setup install code too.
Planning to redo the mail stuff for fuel warning as well
You can contribute by posting changes or email me changes. I was not aware the was a problem with multiple keys, there is just no point in adding multiple keys from the same corp. Only thing I had planned for the install code was adding support for changing the table prefix.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.30 20:21:00 -
[52]
2.1.0 Beta 2 Released
This is everything in the SVN as of Reversion 117 bundled up.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.31 19:12:00 -
[53]
Originally by: Ktor Installed Beta2 over Beta1
All registered corp members could not log in till I deleted and had them recreate there accounts.
I changed the password.php file to fix the password salting. Its in the readme file and it was also in the release notes not to overwrite this file if you have a working installation unless you want to delete and re-add all of your users. I also mentioned that I changed it a few post back in this thread.
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.01 19:06:00 -
[54]
Originally by: Beseiged I'm getting an error:
Fatal error: Call to undefined function curl_init() in /var/www/www.rimcrc.com/htdocs/pos/addapi.php on line 64
When i try to add an api key.
On the first page of the install script, did it say Yes by the 3 php extentions listed, specifically CURL? If you do not remember, you can safely open the first page again, just do NOT click next.
Originally by: Myrdyr Is anyone having any problems with the Optimum fuel calculator not working in editpos.php ?
Not working in what way? Wrong quantities? No quantities?
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.01 19:58:00 -
[55]
Originally by: Aria Minasa
oohhhh it didn't say curl ok. Hmm... maybe should have the next button disabled with a prompt saying, curl needs to work.
Was considering it, but it is possible to use the tracker without it but many of the nicer features would be broken. I may add something to make it more obvious that you may have issues if you continue.
Originally by: CDLHamma Won't even install for me at all, prompts to download the install.php in firefox and gives a DNS error of all things in IE
It sounds like your web host is configured wrong?
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.01 20:23:00 -
[56]
Originally by: CDLHamma Nope everything is good, all the required apps PHP5 and everything. Also running PHP/MySQL forums and such. The index.php runs but the install.php does nothing.
Thats very odd, all install.php does is display information about your config.php file and some server settings. It should be located in a subdirectory called install, so http://yourhost.com/pos/install/install.php
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.02 06:26:00 -
[57]
Originally by: Myrdyr
Originally by: Johnathan Roark
Originally by: Myrdyr Is anyone having any problems with the Optimum fuel calculator not working in editpos.php ?
Not working in what way? Wrong quantities? No quantities?
shows zero for all quantities
I really haven't changed anything in editpos.php. Only thing I did was removed a bit of old code that makes all gallente, mimnatar, and caldari towers treated as Amarr towers. What race are your towers?
Corporation Management Improvement |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.03 20:22:00 -
[58]
Originally by: Myrdyr mine are gallente. i've updated from both SVN and the beta2 release w/ no change so I am guessing it must be a database issue. can you point me towards which tables i can try restoring? I really don't want to lose the POS structures and silo data I've got set up...
check your tower_static, sovereignty_static, and sovereignty_constellation_static. If what I suspect is going on is correct, you need to reload those tables.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.05 07:23:00 -
[59]
Originally by: XFranc
Hi there,
Great application this!
Came across a couple of errors that i havent seen posted yet :
Your silos aren't setup and you really shouldn't post the link to your tracker, although I am rather sure all the security holes have been found, its probably better that you don't help anyone by telling them where it is
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.05 07:52:00 -
[60]
Imports/Exports
I am looking at adding at adding some importing and exporting to POS-Tracker. I am not sure how far to take it though. I could export all the fields in tower_info, plus structues. I am leaning toward something like the following:
<pos-tracker version="0.1"> <currentTime>2008-02-05 07:10:52</currentTime> <pos> <tower typeID="20060" typeName="Amarr Control Tower Small" itemID="12345675" systemID="30000142" systemName="Jita" moonID="40009081"> <fuelbay/> <structures> <structure typeID="17184" typeName="Ballistic Deflection Array" online="1"/> <structure typeID="27675" typeName="System Scanning Array" online="1"/> <structure typeID="17182" typeName="Warp Scrambling Battery" online="1"/> </structures> </tower> </pos> <cachedUntil>2008-02-05 07:16:52</cachedUntil> </pos-tracker>
This would require some info to be filled in after importing such as owner, outpost, corp and alliance. I am considering adding corp and alliance and leaving everything else out. This would be for a full export. I am also thinking about a more limited export with only structures in addition to the full. This would basically be a way to come up with a predefined tower fitting, export the fitting, and then importing it for every tower that has a similar fit. These would be basically tower templates.
Other Apps There are some other POS tools that use XML to store info as well. I am also looking at adding the ability to import there XML into the tracker. I may also be able to generate an export that these apps can use as well.
POS-Tracker 2.1.0 Hosting |
|
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.07 19:11:00 -
[61]
Originally by: Dan Treva Being able to get a correct fuel calculation by putting in just the CPU/Power grid numbers would be great.
Added 20+ modules, is a painfull process.
If I have a Gallente Control Tower:
CPU: x of 6,750 used PG: x of 3,750,000 used
If there was an API export of POS modules that indicated if they were online/offline, then individual mods would make sense.
I may add something like that as an option.
Originally by: Myrdyr I had a thought along the same lines but lazier -- as long as the updates are at least an hour apart you can do a difference of all the values and autocalculate fuel usage, no? I think assuming max usage is ideal until you get enough API grabs to determine actual usage, which can autoupdate if it detects a change in ratios...
I've considered doing something like that. The main issue is the api is cached for 6 hours. Its likely not to be as accurate. I may do some test on this though.
Originally by: Mark Jones I just got your beta working and have found a small omission in the pos structures. You have reactor which appears to corelate to complex reactor but you have no simple reactor.
One feature that I would like to see is the way you handle silos extended to coupling arrays as I use them in cases where the pos does not have enough cpu to run silos
The names have been changed since I last exported the sturctures. Medium Reactor is the Simple Reactor, Complex Reactor is just called Reactor Array.
As far as coupling arrays, I am planning on redoing the silo code at some point.
Originally by: Myrdyr The Reactor Array is the simple reactor, the Medium Reactor Array is the complex reactor.
Other way around.
I'd like to more opinions on the import/export feature. Am I wasting my time with this?
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.07 20:46:00 -
[62]
Originally by: Mark Jones I verified the cpu usage is that of the complex reactor not the simple.
I am unclear does the program query the api regularly to get fuel levels and such or just when you click the button on the admin panel page?
You have to setup a cron job to run a shell script that will update fuel levels.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.11 16:23:00 -
[63]
Originally by: Yarkan Missing Structures you can choose a Reactor Silo (thats a complex one) but no simple reactor (missing in database)
CCP changed the names, Simple reactor is the same thing as Medium Reactor Array.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.13 06:44:00 -
[64]
Originally by: Research Rachel Love the api stuff but getting errors when adding a tower manually...
Quote: Notice: Undefined variable: name in /home/public_html/AoAPOS/pos-transaction.php on line 220 Could not redirect; Headers already sent.
Also get similar errors on adding structures.
I have no idea why that hasn't shown up before, I'll look into what it should be.
Originally by: Research Rachel
Also, adding an outpost causes
Quote: Notice: Use of undefined constant outpost_name - assumed 'outpost_name'
followed by a load of...
Quote: Notice: Undefined variable:
and changing the station in editpos brings up...
Quote: Notice: Undefined index: outpost_id in /home/ascentof/public_html/AoAPOS/outpost-transaction.php on line 8 Could not redirect; Headers already sent.
I know it was mentioned the outpost stuff is bugged and needs reworking, but just wondering if theres a way to fix all the undefined variables?
Outpost stuff is working fine on all my installations. What version of PHP and MySQL do you have?
Originally by: Fu Jinmei Hi, I have a couple of issues with the cron jobs - I've fixed the mail one with the fix suggested in this thread but the others are still a problem:
the mail stuff will probably be my next project after the import/export stuff is complete.
Originally by: Fu Jinmei
Update POS
<b>Parse error</b>: syntax error, unexpected '{' in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updatepos.php</b> on line <b>51</b><br />
I can not find anything that would cause that. What version of PHP do you have?
Originally by: Fu Jinmei
Update SOV
<br /> <b>Fatal error</b>: Cannot instantiate non-existent class: simplexmlelement in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updatesov.php</b> on line <b>21</b><br />
Update Alliance
<br /> <b>Fatal error</b>: Cannot instantiate non-existent class: simplexmlelement in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updateallianceinfo.php</b> on line <b>23</b><br />
Pull up the first page in the install script, where it says "Required Modules Installed", there should be 'yes' on the 3 lines below it, if any of these say 'No', it is an issue with your host and you may need to contact your hosting provider to have these modules turned on. They should be on by default in php 5.1.2 installations, at least according to all the PHP documentation I have read on these.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.13 20:08:00 -
[65]
Originally by: Research Rachel Current PHP version: 5.2.5 (Needs to be greater than 5.1.2) Your CURL Version: 7.15.3 Required Modules Instealled: CURL: Yes SimpleXML: Yes Hash: Yes
There is actually a very simple solution to your issue, in your php.ini file, find the line error_reporting = E_ALL and change to error_reporting = E_ALL & ~E_NOTICE
The NOTICE errors are generally for developement and the parser can generally figure it out. I will still probably go through the code when I have time and try to correct some of these.
Originally by: IVannaTrump Here is a quick question.
I run a shared account with godaddy cron job, how? anybody with some working knowlede of how to get this feature to work would be of great help as their support staff are clueless.
thx
In the control pannel, there should be a button call Cron Job or something along those lines. Point it to the shell files included, postrackercron.sh and poscron.sh. Give it a dedicated email account as it will fill the box. each host is a little different on exactly how this works
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.14 18:43:00 -
[66]
New Feature Structure List Export/Import - You can now export a towers structure list to XML and import it to MyPOS or another tower. Now if you have 10 towers that have similar structure fits, you only have to enter it once, export it, and then import the list on the other towers. There are currently two styles of Exports: MyPOS Fitting Export and POS-Tracker Fitting Export. MyPOS Fitting Export is to use with the program MyPOS. You will need to change the extentsion to .ptf. POS-Tracker Fitting Export will export the online state of the structure as well and the name of the structure. This feature is currently in the SVN version and the next release will have it.
Example of POS-Tracker Fitting Export:
<?xml version="1.0" encoding="iso-8859-1"?> <pos-tracker version="0.1"> <!--POS-Tracker Fitting Export--> <currentTime>2008-02-10 19:18:14</currentTime> <structures> <structure typeID="27644" typeName="Angel Medium Artillery Battery" online="1"/> <structure typeID="27644" typeName="Angel Medium Artillery Battery" online="1"/> <structure typeID="27644" typeName="Angel Medium Artillery Battery" online="0"/> <structure typeID="17184" typeName="Ballistic Deflection Array" online="1"/> </structures> </pos-tracker>
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.18 18:22:00 -
[67]
Originally by: Research Rachel
Maybe tidy up the track.php page to something like: Parent Outpost, Reinf, Tower Name, Owner, Last Update, Status, Action, Secret POS then a second line... Silo 1, Days, Silo 2, Days (up to maybe 4 as needed?)
I want to redo all the silo code but it will take some time and is planned for 2.2. No point in doing anything to current silo code with the exception of bugs until that is done.
Originally by: Saigo Yumi
some features we "miss": second pos owner, since we administrate each pos in teams of 2
There is some code already in the tracker for a secondary owner. I am guessing you want this for the mail alerts?
Originally by: Saigo Yumi the mail.php is somewhat outdated, i got it working, but it needs some developer love. for example an alert if the silos are full or empty(output/input)
I am planning on doing some work on the mail alerts. Again, no point in adding anything with the silos at this point to redo it in a month or two.
Originally by: Saigo Yumi view the lowest silo time in the pos overview for each pos. it is a little work to open every pos to check the silo status
This is something that is planned with the silo update, but it is still a little ways out. It will be a big change.
Originally by: Saigo Yumi fuel supply locations - we have several locations where we store our fuel for the pos teams
Whats wrong with the outpost tracking for this? It doesn't have to be an outpost.
Originally by: Saigo Yumi an overall pos fuel consumption for a day/week/month of all pos would be nice, too
may be able to do something like this by adapting the outpost code a bit.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.21 07:03:00 -
[68]
Originally by: Fu Jinmei
Update POS
<b>Parse error</b>: syntax error, unexpected '{' in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updatepos.php</b> on line <b>51</b><br />
I can not find anything that would cause that. What version of PHP do you have?
Originally by: Fu Jinmei
Update SOV
<br /> <b>Fatal error</b>: Cannot instantiate non-existent class: simplexmlelement in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updatesov.php</b> on line <b>21</b><br />
Update Alliance
<br /> <b>Fatal error</b>: Cannot instantiate non-existent class: simplexmlelement in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updateallianceinfo.php</b> on line <b>23</b><br />
Are you still having this issue? By what you've posted, there is no reason it shouldn't work. I know I get some strange errors on occation with the API is down or having some issues.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.21 07:25:00 -
[69]
SVN 119 I have updated the SVN. There are some database changes in the user table for a new feature that relates to the Alert emails. The Tracker will now email users to check if an email address is valid. If the email is valid, it will note this in the user table. There is also a field to Opt-In or Out of the alert mails. This is set in the user panel.
There is an update script under the /install subdirectory that will modify the user table (backup first please) and attempt to validate the email address of all users.
The mail script has also been modified. It now knows about the table prefixes. The message also includes the moon location as well. It will not send emails to non-validated email address or to users who have not Opt-in.
Made some changes to the cron update scripts to format the output and provide more information if there is an error.
A packaged version should be out sometime later this week. I want to make a few more tweaks to the install scripts and I am thinking about making it so users can sort some of the fields on the main track page. Don't hold your breath if your hoping the fuel level column will be sorted. Its calculated after the rows have already been sorted.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.21 16:09:00 -
[70]
Originally by: ToxicAid Edited by: ToxicAid on 21/02/2008 10:01:37 Hi
If i load install3.php nothing is show. My Hash is not enabled, maybe this is the cause???
When it is, what can i do?
Most likely, that would be the cause. It is used to hash passwords among a few other things. Open up password.php, uncomment line 14 and comment line 13. I suggest though that you ask your host to enable it as hash works a little bit better. This is normally done by editing your php.ini file, but if you have paid hosting, you may want to ask them how to do it.
POS-Tracker 2.1.0 Hosting |
|
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.21 19:42:00 -
[71]
Edited by: Johnathan Roark on 21/02/2008 19:45:00
Originally by: Saigo Yumi
i updated to 119, but the update script bugged. you forgot to uncomment the line 11: $result = mysql_query($sql) or die('Could not modify user;' . mysql_error());
then the script send out a bunch of emails, but the validation links were all wrong :( so i had to update the database manually to set the email_valid field
doh!
Originally by: Saigo Yumi
Edit: It's also impossible to change my own password, it always says "Password Change failed"
An Admin Option to reset an User Password (with Access level 4 of course) would be nice also, becaus one user forgot his password.
I've looked into that, there really is no good way to do it other than to delete the user and make them register again. The password change thing is broken, I'll look into how to fix it.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.22 07:16:00 -
[72]
Originally by: Shime Ive just all reinstall and update with last svm. I ve the same error : "Failed, try again." when i create the admin login/pass
I'm guessing you don't have sendmail or something along those lines? I'll probably have to add a way to disable the mail system
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.23 18:58:00 -
[73]
Originally by: Jomanda I found that some faction mods have incorrect PG/CPU data. I know for sure Shadow/serpentis rail guns have too high PG usage.
Without the IDs and correct values, that statement does not do me any good. I exported all the structures from the eve database and I am not about to go through and check every faction module to see if its wrong.
Originally by: Saigo Yumi I found another bug:
in the fuel_calculator.php are some ".TBL_PREFIX." missing, around line 27 and 31 i think (i've fixed it and i'm too lasy to check the lines again)
Found them, fixed in the SVN.
Originally by: Saigo Yumi
and another bad behaviour: if you create an outpost as user 1 (admin) and you don't have altered the eveid/corp settings for this char, they are pretty much unusable for other users (level 1 and 2).
Thats actually correct, the defualt admin account should only be used to change user access levels and run the updates. The admin account is not in a corp or alliance.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.25 04:39:00 -
[74]
Originally by: La Merovingian After entering the admin e-mail address and password and clicking "next" I get the message: "Could not create user;Field 'alliance_id' doesn't have a default value"
Any suggestions?
Thanks in advance
Run this using your database software such as myphpadmin: ALTER TABLE `pos2_user` CHANGE `alliance_id` `alliance_id` INT( 20 ) NOT NULL DEFAULT '0'
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.25 20:18:00 -
[75]
Originally by: Research Rachel looks like an old issue has slipped in too.
When you have constellation sov, sov 5 should only be in the capital system and not surrounding systems.
I am very sure that you should get a fuel bonus for all constellation systems. I know the bonus doesn't display correctly in the capital, but not sure if its actually applied in non-capital systems.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.03.02 19:59:00 -
[76]
Originally by: Johnathan Walker Bug: When sovereignty is held by the alliance, the tracker displays sovereignty status as "hostile"
are you using the admin account or an account in the alliance that has sovereignty?
Originally by: Altamekz
Notice: Undefined variable: count in C:\www\pos\updatesov.php on line 47 Could not update sov; Out of range value for column 'constellationSovereignty' at row 1
Two issues here, first run this on your database: ALTER TABLE `pos2_system_status` CHANGE `constellationSovereignty``constellationSovereignty` INT( 20 ) NOT NULL DEFAULT '0' Most mysql installations it doesn't matter, it just fills the field with the max value if it wont fit. The tracker just needs this to be greater than 1.
Originally by: Altamekz
Notice: Undefined variable: row in C:\www\pos\updatepos.php on line 13
Notice: Undefined variable: version in C:\www\pos\updatepos.php on line 27 Error: 209
The 'Error: 209' is an eveapi error code, it means the the key is not a director or ceo.
for the error on line 27, add $version=2 before $data = array(
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.03.03 20:23:00 -
[77]
Originally by: Johnathan Walker
Originally by: Johnathan Roark
Originally by: Johnathan Walker Bug: When sovereignty is held by the alliance, the tracker displays sovereignty status as "hostile"
are you using the admin account or an account in the alliance that has sovereignty?
Both actually; neither of the two accounts show proper fuel calculations. I also tried setting the "owner" of each pos to an account that is within a corp within the alliance; this has not worked either.
In the user panel, click on the button that says "Update Corp/Alliance". I am guessing your alliance has changed since you've registered on the tracker.
Originally by: Padyn
Originally by: Johnathan Roark
Originally by: Altamekz Notice: Undefined variable: version in C:\www\pos\updatepos.php on line 27 Error: 209
The 'Error: 209' is an eveapi error code, it means the the key is not a director or ceo.
I added this function to functions.php function getError($err) { //Sets the location of the eveapi xml file to parse $url="http://api.eve-online.com/eve/ErrorList.xml.aspx";
//Begins connecting to eve api
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HEADER, false); curl_setopt($ch, CURLOPT_POST, 1);
//Create XML Parser $xml = new SimpleXMLElement(curl_exec($ch)); curl_close($ch);
//Parse the file foreach ($xml->xpath('/eveapi/result/rowset/row') as $row) { if($err == my_escape($row['errorCode'])) return my_escape($row['errorText']); } } and changed all occurrences of:echo "Error: ".$error['code']."<br>\n"; to echo "Error: ".getError($error['code'])."<br>\n";
so it displays EVE error text and user doesn't have search for it.
Good work, but something that should do the samething without another api call, echo "Error Code: ".$error['code']."::".$error."\n"; More error handling is something I do want to improve on.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.03.04 15:56:00 -
[78]
Originally by: Chewie Soloh Edited by: Chewie Soloh on 04/03/2008 13:07:37 Edited by: Chewie Soloh on 04/03/2008 13:03:39 When i got to yourserver.com or whatever (yes i replaced it with localhost and what not) it jsut ends up blank
Step 6. Remove install.php, install2.php create_database.sql, and bigdump.php
I dont have either of those
Your reading the install directions for 2.0.94, look in the readme.txt file. I have no idea if it will work with localhost as the host name, It really depends on exactly how its setup.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.03.15 16:37:00 -
[79]
The POS API is broken. Its returning an non-api error. This is why the tracker is not telling you that it failed.
If you go to http://api.eve-online.com/corp/StarbaseList.xml.aspx?userID=youruserid&apiKey=yourapikey&characterID=yourcharacterid you will see an error page that says "Error Encountered
Sorry, you encountered a fatal error. Please contact the administrators about this if it continues." If you want to give ccp some encoragement on fixing it, file a petition.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.03.19 16:58:00 -
[80]
Originally by: XFranc Hi there,
Im having some strange errors at the moment and I cant tell if its down to the API or not .
When I run the Sov update - I get this :
Not a valid xml string
When I run the Alliance update - I get this :
atal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in /path/pos/updateallianceinfo.php:25 Stack trace: #0 /path/pos/updateallianceinfo.php(25): SimpleXMLElement->__construct('') #1 {main} thrown in /path/pos/updateallianceinfo.php on line 25
Any advice would be appreciated.
Thanks,
Try it again later. As for the complaints about the POS not updating, the POS API is broken and has been since the patch. This is something CCP will need to fix.
POS-Tracker 2.1.0 Hosting |
|
Johnathan Roark
Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.03.26 16:55:00 -
[81]
Originally by: XFranc
TBH, I dont know why this fixed it, but thought I should share.
That really shouldn't have caused a problem, but Im guessing ccp changed something, as my install has started doing the same thing.
The POS api is now working again!
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.04.10 16:41:00 -
[82]
Originally by: La Vittoria When users are registering, seem to be getting the following error. I have not modified mail.php in anyway way so /me shrugs
Warning: mail() [function.mail]: SMTP server response: 501 <"POS TRACKER"<[email protected]>>: "@" or "." expected after ""POS TRACKER"" in C:\%pathhere%\functions.php on line 737
try changing line 731 to $headers = "From: ".SITE_EMAIL.">\r\n" . see if that works. Also check the actual email setting in your config. It should be just the email address.
Originally by: XFranc Edited by: XFranc on 07/04/2008 15:51:10 Heres a strange one, whenever I do a cron update of the Alliance info - I get this error at the start of the mail :
could not get pos_info; Table '.pos_info' doesn't exist
I can not find any refrences to pos_info in cron_updateallianceinfo.php, that was the old name of the the database table tower_info. What version are you running?
Originally by: Slayton Ford
Originally by: Slayton Ford Setting the tracker up from scratch. when I try to update POS from API, i get "Could not insert values into tower_info; Incorrect integer value: 'NULL' for column 'pos_id' at row 1"
Turns out this is caused by a MySQL setting.
Yes, you have strict mode on which is default for windows installations. I am still new when it comes to proper SQL. If anyone wants to volunteer to go through and fix all of the mistakes in the sql statements I would be happy, especially if you explained why it needed changing.
Originally by: Zeoliter This has to be the most worthless piece of w@nk app coded for eve that I ever saw.
Lets see yours?
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.04.12 04:40:00 -
[83]
Originally by: Gorespawn Hey, i am having a big issues here, i installed teh latest packagesa from your sourceforge mirror and was unable to install it. I tried it twice, steps doen were as follows:
1. unpacked 2. changed files from readme 3. uploaded 4 went to phpmyadmin, created database 5. added database info on the dist.php thingy 6. uploaded changed files 7. went to server/directory/install/install.php --> did see a normal header and a menue linking back to server/directory/install/login.php etc not server/directory/login.php ... did not see any installsteps went to install2.php - same thing.
Whats wrong or what am i doing wrong ?
view source, see if there are any errors that aren't showing up. There isn't really anything in install.php that should cause any problems. Also, make sure config.dist.php is renamed to config.php. Another thing to check is if your host is set to display errors in php.ini.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.05.15 07:15:00 -
[84]
Originally by: skilzrulz
Originally by: skilz I would like to see a run cost calculator add on, any chance of that?
yes/no?
both, although it would not be very hard to do, and have considered adding it, I do not currently have the time or will to do it. I will probably go through and fix all the bugs i can find soon and take the 2.1 branch out of beta status. If anyone would like to contribute, a good place to start is by cleaning up the sql. I would rather not add any more features at this point.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.05.16 05:28:00 -
[85]
Originally by: Lillis85 What is the word on the low fuel warning mails the tracker should send out? I keep getting the error "No recipient addresses found in header" from the script. Have been trying to fix it, but can't see where the problem is. Any help please?
Check your config file, there should be a setting in it for the tracker email.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Quantum Industries RAZOR Alliance
|
Posted - 2008.06.03 06:05:00 -
[86]
Originally by: Flybye Hi,
I'm not too familiar with PHP and have a simple question.
On this line: define('REDIRECT_PATH', 'http://'.$_SERVER['HTTP_HOST'].'/pos/');
I see several ' ' where I can place my url. Exactly how should this line look using www.myurl.com as an example?
it detects the host name, you just need to change the last part '/pos/' to reflect the exact folder where you intall it, so if your tracker is installed at http://www.myrul.com/postracker/, you need to change that line to define('REDIRECT_PATH', 'http://'.$_SERVER['HTTP_HOST'].'/postracker/');
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Quantum Industries RAZOR Alliance
|
Posted - 2008.06.04 05:00:00 -
[87]
Originally by: Apocalytica Insomnia Edited by: Apocalytica Insomnia on 03/06/2008 13:56:34 Which reminds me to ask:
firstof all, in teh *********.sh files, i need to change the part, does this need to be the path where teh file is located at ?
It needs the absolute path of that file on your server, this has very little to do with the url.
Originally by: Apocalytica Insomnia
I have no clue how to setup the cronjob. I'm using a Plesk-admin-software on my Server, so i now need to add following values:
Minute Hour Day of teh Month month day of teh week and command, (which is obviously teh path top teh ****.sh file.
Now lets say i need to add a chronjob to run every hour at xx:21 and i need one to run one at 15:19 every day, how would i go about this ?
it varies with the admin software your host is running, i would look it up in its documentation.
Originally by: Apocalytica Insomnia
Also, since i'm already posting, i'm wondering if there is away to "get rit" of having to add all teh modules for fuel calculations to get CPU/Pg values.
While this might be a nice idea, and good for players running only minimal posses, it gets kinda stressfull if your managing alot of posses and justtakes long.
Thanks in advance.
Although it is posible, it would need several code changes to do this. In the SVN version, it also supports some import and export functions that work with another pos program called MyPOS.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Quantum Industries RAZOR Alliance
|
Posted - 2008.06.25 16:38:00 -
[88]
Originally by: DeTox MinRohim Edited by: DeTox MinRohim on 25/06/2008 12:46:05 Is this project still alive?
Just wondering as I made myself a lot of modifications over time. I don't remember exactly wich version I took (v2 that's sure but I didn't follow SVN).
Database optimisation (ADODB) Templated the major pages (Smarty) Code Optimisation/Fix HTML tidy Various modifications (Silo ouput links for example)
Few screenies (Templated pages) : http://eve.onewayweb.com/images/shots/pos/index.html
Could take a while to clean my mess though before shooting this in the public.
Id like to see your changes and possibly work them into the current svn version.
Originally by: Frendor Edited by: Frendor on 25/06/2008 11:32:47 I've just had a look through the "install_database.sql" within the install folder (POS-Tracker2.1.0beta2\install) and found all 11 advanced material values are wrong!
CCP changed the outputs and I never got around to updating this. Samething with the silo re-work, requires more time then I have for it right now. Silos are currently hardcoded to 20,0000 m3 of space. I was intending to change this to be stored in the database. If all your towers are the same, you can change it in viewpos.php on line 229.
Originally by: Konosbe Please make the download available as .tar.gz or bz2
RAR hurts my "lunax skillz".
Thanks, - K
I'll keep that in mind next time I actually put together a download package, but right now, your better off using SVN.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.07.23 07:18:00 -
[89]
POS-Tracker 3.0.0 Beta 1 Somethings to keep in mind with this new release: Its not directly compatible with 2.x. I suggest using a fresh install then importing your fittings using the fit import/export. I do not expect to have a need to change the database again, but it could happen. The devs have not released an offical eve database dump, so Black Rise is missing.
The outpost and alert mails are not in yet. I will try to get them done sometime in the next few weeks.
If you find any bugs, post them in this thread. I would also like hear about any features, fixes, mods, templates, etc. Please contact me if you have any of those.
P.S - If anyone is good at making images, I would like an official POS-Tracker banner to place at the top.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.07.25 06:18:00 -
[90]
Originally by: p00ky actually scrap the above i sorted all that.
My only other question is on the tracker page can you sort the towers by system order rather than the order in which run out of fuel?
Yes, comment line 112 out in track.php with // in front of it. Line 112 looks like
array_multisort($sortAarr, SORT_ASC, $rows);
What was causing your above issue?
Originally by: Ai Sakura Edited by: Ai Sakura on 24/07/2008 19:48:46 [Thu Jul 24 20:41:06 2008] [error] [client 192.168.1.254] PHP Fatal error: Call to undefined method eveRender::RedirectUrl() in C:\\Server\\HTTPD\\pos\\install.php on line 125, referer: http://pos.xxx.co.uk/install.php?step=2 [Thu Jul 24 20:41:18 2008] [error] [client 192.168.1.254] PHP Notice: Use of undefined constant cache - assumed 'cache' in C:\\Server\\HTTPD\\pos\\eveconfig\\config.php on line 8 [Thu Jul 24 20:41:18 2008] [error] [client 192.168.1.254] PHP Notice: Undefined variable: mod in C:\\Server\\HTTPD\\pos\\index.php on line 7 [Thu Jul 24 20:41:18 2008] [error] [client 192.168.1.254] PHP Notice: Undefined index: shorturls in C:\\Server\\HTTPD\\pos\\includes\\eveRender.class.php on line 122 [Thu Jul 24 20:41:18 2008] [error] [client 192.168.1.254] PHP Notice: Undefined index: access in C:\\Server\\HTTPD\\pos\\includes\\eveclass.php on line 277 [Thu Jul 24 20:41:53 2008] [error] [client 192.168.1.254] PHP Fatal error: Call to undefined method eveRender::RedirectUrl() in C:\\Server\\HTTPD\\pos\\install.php on line 125
Win2k3, Apache 2, PHP 5.2.6
This happens when getting to Step 3 (After entering the email/password)
I have no idea why this hasn't shown up with anyone else, but line 125 in install.php should look like the following:
$eve->RedirectUrl('install.php?step=2');
Originally by: Audrea I never have installed php sql stuff like that..
Is it possible to relatively easily install it on some free webhosting that offers sql and php support? without console access, cron etc?
I intend on changing the install process some so ill probably redo it anyway.
POS-Tracker 2.1.0 Hosting |
|
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.08.02 05:08:00 -
[91]
Originally by: Clone 985
Originally by: Brunnis Jetrel
Originally by: Slayton Ford Setting the tracker up from scratch. when I try to update POS from API, i get "Could not insert values into tower_info; Incorrect integer value: 'NULL' for column 'pos_id' at row 1"
I get a similar error whilst doing exactly the same, my error is:
ERROR Failed to update tower_info; Incorrect integer value: '' for column 'charters' at row 1"
I managed to sort this out. Went into the My SQL config and disabled 'Strict Mode', and hey presto, it works great.
BTW - This is a truly awesome tool
Yea, Windows mysql servers have strict mode turned on by default, Its on the list of things to do to make it work in strict mode.
Originally by: Shime Edited by: Shime on 02/08/2008 04:20:12 Edited by: Shime on 02/08/2008 04:14:41 Edited by: Shime on 02/08/2008 04:12:44 Hello,
must we import old datas to a new database ? because same as Halada, when i'm trying to update with API, system says that's ok, but nothing was import and track is still empty.
i import pos_tower_info database into a new, now i see all tower, but API don"t work, nothing is updated.
Correction : Alliance list and Sov works with API. But not the POS import position and fuel. And no error message too
When you try to import your pos via api, what do you see? Does it display the main admin page where you have buttons to import or do you get something like the folowing: Administration
Success Total Number of POS Added: Total Number of POS Updated: Total POSes updated from API:
Done
Towers List:
FYI, im currently building updated tables using the new EA eve data dump.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.08.02 18:49:00 -
[92]
Edited by: Johnathan Roark on 02/08/2008 18:49:11 Is the api key owned by a director or the ceo? is it a full key? is the key and userid in the database properly? are you running on apache or something else? Windows, Linux or something else?
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.08.03 10:48:00 -
[93]
Originally by: Shime
import fitting Warning: require_once(config.php) [function.require-once]: failed to open stream: No such file or directory in /pos/importfit.php on line 2 Fatal error: require_once() [function.require]: Failed opening required 'config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /pos/importfit.php on line 2
its been corrected in the svn, it will be correct in the next release, which will be done after I get some sleep. old version got in that release :(
Originally by: Shime
Sov status : Don't work. when do an edit on a POS we can see : Sovereignty: Yes Sovereignty Status: Hostile --> Or thats wrong we have sov.
If your logged in as admin, then yea, it will show up like that.
Originally by: Shime
And how to add an outpost and do you plan to add "Owner" ?
Most of the owner stuff is already in, it just needs enabled along with the code to change it. I will work on getting all the owner stuff enabled and working for the beta3 release. Outpost stuff is also mostly done, but probably wont be activated until the beta4 or 5 release.
For the upcoming release, it be updated for Black Rise. I just need to check one more table. Also, I've updated the email alert system so it should work a lot better. I've fixed some bugs as well.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.08.03 23:04:00 -
[94]
I just updated the svn and did a new release. Normally I update while fixing, but wanted to do some testing on it as a single package.
I've started a new thread for the 3.0.0 BranchPOS-Tracker 3.0.0 Please use it from this point on.
POS-Tracker 2.1.0 Hosting |
Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.08.24 16:52:00 -
[95]
Originally by: CasC Edited by: CasC on 24/08/2008 16:36:15 Im in abit of a pickle here, everytime i try to add a structure to the POS i just setup i get That doesnt work; Duplicate entry '61' for key 1 Atm i have NO structures on that POS.
Anyone know why?
the correct thread, you'll find your answer there
POS-Tracker 2.1.0 Hosting |
|
|
|